Oracle Database 12c brings PL/SQL enhancements in these categories: transparent performance improvements; new PL/SQL language features for better performance, new functionality, and improved programming usability; and new supplied package APIs. This session explains improvements in PL/SQL-to-SQL interoperability, improvements in how PL/SQL subprograms can be invoked from outside of the database, new constructs to improve modularization,…

There is increasing pressure to improve system availability to try to provide 5X9 service. This 99.999% availability requirement means a system can only be unavailable 5 minutes and 15 seconds a year! In other words, it needs to stay up. Using Oracle 12c features, we can now keep the system available for end users through…

Combining Enterprise Manager 12c with Oracle Public Cloud creates the ultimate Public Cloud solution. From discovery, provisioning, monitoring, to configuration management and compliance, Enterprise Manager delivers a comprehensive feature set through a single pane of glass, touching both the consumers and providers of Oracle Public Cloud. In this session, learn how it is used to…

In this hands-on lab, you will learn about new ways to upgrade, migrate, and consolidate databases in Oracle Database 12c. Specifically, you will; Upgrade a database to 12c, using the new command-line parallel upgrade script; Plug that database into an Oracle Database 12c container database as a pluggable database (PDB); Migrate a second database to…

Cloud Control 12c allows Ithaka Harbors to manage its infrastructure, databases and applications (oracle and non-oracle).  This presentation will provide recipes on installing cloud control, setting up groups, plugins, monitoring, notification, security, rules and how to setup up automated routine tasks, and provided reporting capabilities on the history and trends.

Attendees are introduced to new and improved features of Oracle 12c directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, JSON enablement, APPROX_COUNT_DISTINCT function, security enhancements, PL/SQL interoperability improvements, outer-join improvements,…

The session will Introduce key new features that will be available with "Oracle Real Application Clusters 12c Release 2" Introduce best practices for deployment, Management, Availability and Performance tuning Cover internals of the key features so DBA's can understand how the feature will help with their day-to-day activities

Pluggable databases are “not your mother’s database”.   Efficient use of a pluggable database requires attention to not only the SQL being used to access the data in the pluggable database; but also components of the container database and even the structure of both the pluggable and container database.   In a multi-tenant environment, the DBA for the pluggable database might not even have access to the underlying container.  Learn how to use different tools and techniques to ensure your databases are making optimal use of available resources.

Original Broadcast: 5.1.13 Featured Speaker: Victor Mejia, Chief Executive Officer, VLM Systems After completing this workshop, attendees will understand the concepts, and deploy enterprise applications in minutes using Oracle VM Templates, Zero-Downtime Kernel updates, and migration strategies to implement and manage public and private Oracle Clouds. Strategies taught in this session: * How to deploy…